-
Re: Cross-sheet References - New Unknown Statuses
The problem is that we have this issue across majority of our sheets and so we cannot ask for backend refresh of each of them - that would take us ages, rather would need possibly refreshing all (tho…1 · -
IFERROR Formula Should Catch INDEX() Returning #INVALID COLUMN NAME
Recently we noticed that when we have a function that looks like this: =IFERROR(INDEX(COLLECT(...), Index), "") If the Index value was 0 the result of INDEX() was an error (understandably) …2 · -
Outbound Links Monitor on sheets
Since there is a set limit to Outbound Links on a sheet (25 millions) and for core sheets that hold information used in multitude of other sheets this number can be reached easily, it would be good (…3 ·